Explore Weather Trends

Analysis

Criteria Meet Specification

Student is able to extract data from a database using SQL.

  • The SQL query used to extract the data is included.
  • The query runs without error and pulls the intended data.

Student is able to manipulate data in a spreadsheet or similar tool.

Moving averages are calculated to be used in the line chart.

Student is able to create a clear data visualization.

  • A line chart is included in the submission.
  • The chart and its axes have titles, and there's a clear legend (if applicable).

Student is able to interpret a data visualization.

  • The student includes four observations about their provided data visualization.
  • The four observations are accurate.

Tips to make your project standout:

Think about other ways to compare and find insights from this data beyond interpreting the chart. Hear are a few ideas:

  • What's the correlation coefficient?
  • Can you estimate the average temperature in your city based on the average global temperature?
  • Multiple cities - Add your favorite cities from around the globe to your visualization. What do you learn about them?